Model Table PROJ BILLING CATEGORY
This cube dimension represents billing category information in Project Reporting
based on the IFS Applications dimension DIM_PROJ_BILLING_CATEGORY. All cubes that
refers to this dimension will have the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Company Code | Company |
| Proj Billing Category | Key. Displayed as COMPANY_ID + ' - ' + PROJECT_ID + ' -
' + CODE + ' - ' + BILLING_CATEGORY_DESCRIPTION |
| Proj Billing Category Code | Billing category (the code) |
| Proj Billing Category Description | Description of billing |
| Project Id | Project identity |
Hierarchies
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| PROJ BILLING CATEGORY | DIM_PROJ_BILLING_CATEGORY_TM | DIM_PROJ_BILLING_CATEGORY_BI | DIM_PROJ_BILLING_CATEGORY | On Line |